2014-08-22 - 9203.900 - Rel Notes - Migrate Sell Thru Flat File Load to BW - Release 001 #BIReleases2014
Release Notes
9203.900 - Migrate Sell Thru Flat File Load to BW
Admin Info
| Purpose |
Need to migrate Sell Thru Flat file loading to BW. |
| Release No |
001 |
| Submitted on |
22/08/2014 |
| Submitted by |
Uday Kumar P |
| Environment |
NECNED to NECNEQ to NEP & BPD to BPQ & BPP. |
| Sent To |
Greg Jackson |
| Object(s) created by |
Uday Kumar P |
| Object(s) tested by |
Uday Kumar P |
| Transport Status |
Created in NECNED100 & NECBPD - Released. |
Transport and Technical Objects
ECC Transports
| SNo |
Transport ID |
Description |
Object Name |
| 1 |
NEDK927005 |
BW: Enhance J_3ASTCU in 0CUSTOMER_ATTR Datasource. |
0CUSTOMER_ATTR |
| 2 |
NEDK927007 |
BW: Generic DataSource ZSD_KNVP. |
ZSD_KNVP. |
| 3 |
NEDK927013 |
BW: Generic DataSource ZKOTD498. |
ZKOTD498 |
| 4 |
NEDK927017 |
BW: Generic DataSource ZAFS_DPRG_KOND. |
ZAFS_DPRG_KOND |
| 5 |
NEDK927035 |
BW: Generic DataSource ZKONDD. |
ZKONDD. |
| SNo |
Transport ID |
Description |
Object Name |
| 1 |
BPDK901687 |
BW: Enhance J_3ASTCU field to 0CUSTOMER_ATTR Datasource. |
0CUSTOMER_ATTR |
| 2 |
BPDK901700 |
BW: InfoObjects For Sell Thru Data. |
0AF_REQCAT, 0KNUMH, 0OI_PARVW, ZJ_3ADLDB, ZJ_3ADLDV, ZJ_3AUDTB, ZJ_3AUDTV, ZMATDETTY and 0RSPL_CNTER |
| 3 |
BPDK901702 |
BW: Dataflow for ZSD_KNVP DSO. |
ZSD_KNVP |
| 4 |
BPDK901704 |
BW: Dataflow for ZKOTD498 DSO. |
ZKOTD498 |
| 5 |
BPDK901706 |
BW: Dataflow for ZKONDD DSO. |
ZKONDD |
| 6 |
BPDK901708 |
BW: Dataflow for ZAFSCOND DSO. |
ZAFSCOND |
| 7 |
BPDK901710 |
BW: Dataflow for 0AFIO_DS1(Season & Collection) DSO. |
0AFIO_DS1 |
| 8 |
BPDK901685 |
BW: Sell Thru Migration Dataflow changes. |
ZSD_OSEL & ZSD_SELT |
Release Notes
For Infrastructure
1. ECC transport requests need to moved to NECNEQ & NEP.2. Notify us once the ECC transports are moved, so that we will replicate the datasources into BPQ & BPP respectively.
3. BW Transport requests need to moved to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
4. Need to move the above transport requests in the same sequence as specified above.
For Requestor
ECC Transports1. The first transport request will move the enchancement of Store(J_3ASTCU) field in customer master to NECNEQ & NEP.
2. The second transport request will move the newly created generic datasource ZSD_KNVP to NECNEQ & NEP.
3. The third transport request will move the newly created generic datasource ZKOTD498 to NECNEQ & NEP.
4. The fourth transport request will move the newly created generic datasource ZAFS_DPRG_KOND to NECNEQ & NEP.
5. The fifth transport request will move the newly created generic datasource ZKONDD to NECNEQ & NEP.
BW Transports
1. The first transport request will move the newly added Store field in 0CUSTOMER _ATTR Datasource to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
2. The second transport request will move the newly created infoobjects to 0AF_REQCAT, 0KNUMH, 0OI_PARVW, ZJ_3ADLDB, ZJ_3ADLDV, ZJ_3AUDTB, ZJ_3AUDTV, ZMATDETTY and 0RSPL_CNTER to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
3. The third transport request will move the dataflow for newly created DSO ZSD_KNVP to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
4. The fourth transport request will move the dataflow for newly created DSO ZKOTD498 to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
5. The fifth transport request will move the dataflow for newly created DSO ZKONDD to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
6. The sixth transport request will move the the dataflow for newly created DSO ZAFSCOND to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
7. The seventh transport request will move the dataflow for DSO 0AFIO_DS1 to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
8. The eighth transport request will move the dataflow for Sell Thru DSO(ZSD_OSEL) & Cube(ZSD_SELT) to BPQ(BW 7.3 Quality) & BPP(BW 7.3 production).
Test Notes
BW Development(BPD):
Test Case for NEC Material:
| SNo |
Company |
Store |
Lids MID |
Expected NEC MID |
Actual NEC MID |
Pass/Fail |
| 1 |
0001000018 |
7719 |
000000000000000700 |
10000219 |
10000219 |
Pass |
| 2 |
0001010521 |
7719 |
000000000000000678 |
Blank |
Blank |
Pass |
| 3 |
0001000023 |
7719 |
000000000000000638 |
Blank |
Blank |
Pass |
Test Case for Sold To:
| SNo |
Company |
Store |
Lids MID |
NEC MID |
Expected Ship To |
Actual Ship To |
Pass/Fail |
| 1 |
0001000007 |
1171 |
000000000020509045 |
70099015 |
0001000007 |
0001000007 |
Pass |
| 2 |
0001000023 |
1111 |
000000000020509045 |
70099015 |
0001000023 |
0001000023 |
Pass |
Test Case for Ship To:
| SNo |
Company |
Store |
Lids MID |
NEC MID |
Expected Sold To |
Actual Sold To |
Pass/Fail |
| 1 |
0001000007 |
1171 |
000000000020509045 |
70099015 |
0001000007 |
0001000007 |
Pass |
| 2 |
0001000023 |
1111 |
000000000020509045 |
70099015 |
0001000023 |
0001000023 |
Pass |
Test Case for AFS Season:
| SNo |
Company |
Store |
Lids MID |
NEC MID |
Expected AFS Season |
Actual AFS Season |
Pass/Fail |
| 1 |
0001000011 |
1171 |
000000000020368721 |
90001098 |
100 |
100 |
Pass |
| 2 |
0001000018 |
1111 |
000000000020368721 |
90001098 |
100 |
100 |
Pass |
Test Case for AFS Collection:
| SNo |
Company |
Store |
Lids MID |
NEC MID |
Expected AFS Collection |
Actual AFS Collection |
Pass/Fail |
| 1 |
0001000011 |
1171 |
000000000020368721 |
90001098 |
322 |
322 |
Pass |
| 2 |
0001000018 |
1111 |
000000000020368721 |
90001098 |
322 |
322 |
Pass |
NECNED300 Output: This output is as per the previous program that populates the data into ZSELLTHRU table in ECC:
BPD Output: This output is as per the development and lookup logic written in BW to populate the DSO & infocube:
BW Quality(BPQ):
Test Case For Ship To:
| S.o |
Customer |
Store |
Material |
LIDS Material |
Expected SHIPTO |
Actual SHIPTO |
Pass/Fail |
| 1 |
0001006296 |
7719 |
10963536 |
000000000020565846 |
2056340 |
2056340 |
Pass |
| 2 |
0001006296 |
9205 |
70093048 |
000000000020446301 |
2056343 |
2056343 |
Pass |
| 3 |
0001006296 |
9231 |
Blank |
000000000020556218 |
Blank |
Blank |
Pass |
Test Case For Sold To:
| SNo |
Customer |
Store |
Material |
LIDS Material |
Expected Sold TO |
Actual Sold TO |
Pass/Fail |
| 1 |
0001006296 |
7719 |
10963536 |
000000000020565846 |
1006296 |
1006296 |
Pass |
| 2 |
0001006296 |
9205 |
70093048 |
000000000020446301 |
1006296 |
1006296 |
Pass |
| 3 |
0001006296 |
9231 |
Blank |
000000000020556218 |
1006296 |
1006296 |
Pass |
Test Case for AFS Season:
| SNo |
Customer |
Store |
Material |
LIDS Material |
Expected AFS Season |
Actual AFS Season |
Pass/Fail |
| 1 |
0001006296 |
9200 |
10741797 |
000000000020453997 |
CUS |
CUS |
Pass |
| 2 |
0001006296 |
9034 |
10934015 |
000000000020579239 |
Blank |
Blank |
Pass |
| 3 |
0001006296 |
7719 |
10797337 |
000000000020489743 |
RES |
RES |
Pass |
Test Case for AFS Collection:
| SNo |
Customer |
Store |
Material |
LIDS Material |
Expected AFS Collection |
Actual AFS Collection |
Pass/Fail |
| 1 |
0001006296 |
9200 |
10741797 |
00000000020453997 |
000 |
000 |
Pass |
| 2 |
0001006296 |
9034 |
10934015 |
00000000020579239 |
Blank |
Blank |
Pass |
| 3 |
0001006296 |
7719 |
10797337 |
00000000020489743 |
5572 |
5572 |
Pass |
Reference Document(Specification)
2014-08-11 - 9203.900 - Spec - Migrate Sell Thru Flat File Load to BW